When you define multiple filters, by default they join using "AND", which narrows the results.
However, if you add multiple filters on the same object Property (such as StateProvince), by default the filters join with an "OR" connective, which broadens the results.
Therefore, to use the same object Property in an "AND" join, you need to create those filters separately.
For example, to define a filter to obtain customer records in Texas AND in Virginia, first create one filter (where StateProvince = TX) and then select Add Filter to define the second part (where StateProvince = VA).
10.6 Production Release. Updated 7/27/2006 3:52:54 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.